<?php

namespace App\DataTables\Transporter;

use App\Enums\RideRequestStatus;
use App\Models\Request;
use App\Models\RideRequest;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class RequestDataTable extends DataTable
{
    /**
     * Build the DataTable class.
     *
     * @param QueryBuilder<Request> $query Results from query() method.
     */
    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))
            ->addIndexColumn() 
            ->addColumn('ride_type', function ($row) {
                if(isset($row->booking)) {
                    return $row->booking->ride_type_name;
                }
                return null;
            })
            ->addColumn('booking_type', function ($row) {
                return $row->booking->booking_type == 1 ? 'One Way' : 'Two Way';
            })
           ->addColumn('locations', function ($row) {
                $pickup = $row->booking->locations['pickup_location'] ?? null;
                $drop   = $row->booking->locations['drop_location'] ?? null;

                if ($pickup && $drop) {
                    return '<div style="text-align:center">'
                    . $pickup . '<br>to<br>' . $drop .
                    '</div>';
                } elseif ($pickup) {
                    return $pickup;
                } elseif ($drop) {
                    return $drop;
                }

                return '-';
            })
             ->addColumn('date', function ($row) {
                $fromDate = \Carbon\Carbon::parse($row->booking->dates['from_date'])->format('d-m-Y');

                if (!empty($row->booking->dates['to_date'])) {
                    $toDate = \Carbon\Carbon::parse($row->booking->dates['to_date'])->format('d-m-Y');
                    return $fromDate . ' to ' . $toDate;
                }

                return $fromDate;
            })
             ->addColumn('pickup_time', function ($row) {
                $pickupTime = \Carbon\Carbon::parse($row->booking->times['pickup_time'])->format('h:i A');

                if ($row->booking->booking_type == 2 && isset($row->booking->times['return_time'])) {
                    $returnTime = \Carbon\Carbon::parse($row->booking->times['return_time'])->format('h:i A');
                    return $pickupTime . ' / ' . $returnTime;
                }

                return $pickupTime;
            })
            ->addColumn('fare', function ($row) {
                if (isset($row)) {
                    return '₹ '.number_format($row->booking->rides->sum('fare'), 2);
                }
                return null;
            })
            ->addColumn('distance_km', function ($row) {
                $ride = $row->booking->rides->first();
                return $ride?->distance_km . ' km'  ?? '-';
            })
            ->addColumn('no_of_passengers', function ($row) {
               if (!empty($row->booking->no_of_passengers)) {
                    return $row->booking->no_of_passengers ?? '-';
                }
                return '-';  
            })
            ->addColumn('status', function ($row) {

                if ($row->status == \App\Models\RideRequest::PENDING){
                    return '<span class="badge badge-warning text-white px-3 py-2 display-4 ml-4">Pending</span>';

                }
                elseif($row->status == \App\Models\RideRequest::REJECTED){

                    return '<span class="badge badge-danger text-white px-3 py-2 display-4 ml-4">Rejected</span>';
                }
                elseif($row->status == \App\Models\RideRequest::ACCEPTED){

                    return '<span class="badge badge-success text-white px-3 py-2 display-4 ml-4">Accepted</span>';
                }
                else{

                    return '<span class="badge badge-secondary text-white px-3 py-2 display-4 ml-4">Expired</span>';
                }
            })
            // ->addColumn('created_at', function ($row) {
            //     return date('d-m-Y', strtotime($row->created_at));
            // })
            ->addColumn('action', function ($row) {
                $buttons = '<div class="table-actions d-flex">';
                    
                    $buttons .= '
                        <a href="' . route('request.view', encrypt($row->id)) . '" class="btn btn-primary btn-sm" title="view">
                            <i class="fa fa-eye"></i>
                        </a>';
                    // if ($row->status == RideRequestStatus::PENDING->value) {
                        $buttons .= '
                            <button type="button" data-url="' . route('request.accept', encrypt($row->booking->id)) . '" class="btn btn-success btn-sm accept" data-id="' . encrypt($row->booking->id) . '" title="Accept">
                                <i class="fa fa-check"></i>
                            </button>';
                        $buttons .= '
                            <button type="button" data-url="' . route('request.reject', encrypt($row->booking->id)) . '" class="btn btn-danger btn-sm reject" data-id="' . encrypt($row->booking->id) . '" title="Reject">
                                <i class="fa fa-ban"></i>
                            </button>';

                    // }

                $buttons .= '</div>';

                return $buttons;
            })
            ->rawColumns(['status', 'action','locations'])
            ->setRowId('id');
    }

    /**
     * Get the query source of dataTable.
     *
     * @return QueryBuilder<Request>
     */
    public function query(RideRequest $model): QueryBuilder
    {
        $transporterId = auth()->guard('trans')->user()->id;
        return $model->newQuery()->where('transporter_id', $transporterId)->where('status', RideRequestStatus::PENDING->value)->latest();
    }

    /**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
                    ->setTableId('request-table')
                    ->setTableAttribute('class', 'table table-striped table-bordered dt-responsive nowrap jambo_table bulk_action')
                    ->columns($this->getColumns())
                    ->minifiedAjax(route('request.index', [], true))
                    ->orderBy(1)
                    ->selectStyleSingle()
                    ->responsive(true)
                    ->autoWidth(false)
                    ->buttons([
                        // Button::make('excel'),
                        // Button::make('csv'),
                        // Button::make('pdf'),
                        // Button::make('print'),
                        // Button::make('reset'),
                        // Button::make('reload')
                    ]);
    }

    /**
     * Get the dataTable columns definition.
     */
    public function getColumns(): array
    {
        return [
            Column::make('DT_RowIndex')->title('S.No')->orderable(false)->searchable(false),
            Column::make('ride_type'),
            Column::make('booking_type'),
            Column::make('locations'),
            Column::make('date'),
            Column::make('pickup_time'),
            Column::make('distance_km')->addClass('none'),
            Column::make('fare')->title('Total Fare'),
            Column::make('no_of_passengers')->title('Passenger')->addClass('none'),
            Column::make('status'),
            // Column::make('created_at'),
            Column::computed('action')
                  ->exportable(false)
                  ->printable(false)
                  ->width(60)
                  ->addClass('text-center all'),
        ];
    }

    /**
     * Get the filename for export.
     */
    protected function filename(): string
    {
        return 'Request_' . date('YmdHis');
    }
}